Managing Redo log   «Prev  Next»
 

Manually Switching Log Files - Quiz


1. What is it called when Oracle stops writing to one redo log group and begins writing to another?
Please select the best answer.
  A. A group switch
  B. A log switch
  C. A redo switch
  D. A member switch

2. Why might you want to have Oracle manually switch to writing a new redo log group?{{{Please verify this change}}}
Please select all the correct answers.
  A. You need to add a member to the group that is currently being written.
  B. You need to improve performance by doing the log switch yourself.
  C. You need to drop a member from the group that is currently being written.
  D. You don't want the database to stop because the current log file group becomes full.

3. Which of the following commands will cause Oracle to begin writing to a new redo log file group?
Please select the best answer.
  A. alter database switch logfile;
  B. alter system switch logfile;
  C. alter redo log switch group;
  D. alter system switch logfile group;